<body link = "white" alink = "white" vlink = "white" text = "white">
<center><table width = "500" height = "100%" BORDER = "0" cellspacing = "0" cellpadding = "0" valign = "top" background = "fondotexto2.png"><tr><td><table height = "100%" width = "100%">


<tr><td align = "center"   background = "fondotexto.png" >
<hr><CENTER><B>MOVIMIENTOS<hr>
</td></tr>
<tr valign = "top" height = "100%"><td>
<table cellspacing = "0" cellpadding = "0" border = "1" width = "100%"><tr><tD>
<center>&nbsp;</center><hr>

<table cellspacing = "0" cellpadding = "0" border = "1" width = "100%"><tr><tD>

<table width = "100%"><tr><td align = "center">
<center>&nbsp;</center>
<hr>







<TABLE width = "100%" border = "0" cellspacing = "0" cellpadding = "0"><!--<TR  background = "fondotexto.png" bgcolor = "white">
<TD align = "left"><B>FECHA</B></TD>

<TD align = "left"><B>IMPORTE</B></TD>

<TD align = "left"><B></B></TD>








</td></tr>
<TR><TD COLSPAN = "3"><HR></TD></TR>
-->

<?include("../conectarse.php");

$consulta = "SELECT *
FROM `prestamos`, `solicitantes`
where prestamos.pres_estado like '2' and prestamos.pres_id_solicitante = solicitantes.sol_id";
$resultado = mysql_query($consulta);

while($fila=mysql_fetch_array($resultado)){
?>
<tr background  ="fondotexto2.png">
<td><font color = "#212121"><b><?echo substr($fila['pres_fecha_alta'],0,4)."-".substr($fila['pres_fecha_alta'],4,2)."-".substr($fila['pres_fecha_alta'],6,2);?></td>

<td><font color = "#414141"><b>$<?echo $fila['pres_importe'];?></td>

<td><font color = "#414141"><b>$<?echo $fila['sol_nombre'];?></td>

<td><font color = "#414141"><b>$<?echo $fila['sol_apellido'];?></td>

<td><font color = "#414141"><b>$<?echo $fila['sol_tipo_doc'];?></td>

<td><font color = "#414141"><b>$<?echo $fila['sol_nro_doc'];?></td>

<td><font color = "#414141"><b></td>

</tr><?}
?>


<?$consulta = "select * from prestamos where pres_estado like '2'";
$resultado = mysql_query($consulta);
/*while ($fila=mysql_fetch_array($resultado)){
$idcarpeta = $fila['pres_id'];

$update = "UPDATE `wi530914_mutuar`.`prestamos` SET `pres_estado` = '3' WHERE `prestamos`.`pres_id` =$idcarpeta;
";
$updated = mysql_query($update);
*/
//}
?>

</table>






























</td></tr></table><form action = "index.php"><BR><CENTER></CENTER>
<BR><CENTER><INPUT TYPE = "SUBMIT" VALUE = "Aceptar"></CENTER>
</td></tr></table></td></tr></table>